CREATE TABLE test (
  _id INTEGER NOT NULL PRIMARY KEY,
  date1 TEXT NOT NULL DEFAULT LOCALTIME,
  date2 TEXT NOT NULL DEFAULT LOCALTIMESTAMP
);

UPDATE test
SET date1 = LOCALTIME,
    date2 = LOCALTIMESTAMP;

UPDATE test
SET date1 = LOCALTIME,
    date2 = LOCALTIMESTAMP
WHERE date1 > LOCALTIME;
